2014-12-11 - 16175 - Spec - Monthly Inventory Turn Logic #InventoryManagement #InventoryManagement
SPECIFICATIONS
16175 - Monthly Inventory Turn Logic
Purpose
It has been identified that new fields need to be added to the monthly inventory DSO. Currently there is a field for Last Month's Sales, we need to add fields for Last 3 Month's Sales and Last 12 Month's Sales.
Admin Info
Purpose
|
Need to update the last 3 Months & last 1 year sales quantities to Monthly Inventory DSO.
|
Requested By
|
Jim Patterson
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
12/11/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZDSOINVM
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
12
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Other activity
|
00
|
|
TOTAL
|
24
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
It has been identified that new fields need to be added to the weekly inventory DSO. Currently there is a field for Last Month's Sales, we need to add fields for Last 3 Month's Sales and Last 12 Month's Sales.
In Scope:
Changes in Weekly Inventory source only.
Out of Scope:
None
Solution Summary
1. Need to create 2 key figures for last 3 months & last 12 Months sales quantities.
2. Need to add the key figures to Weekly inventory DSO and Infocube.
3. Need to write the logic for populating the newly added key figures.
4. Need to unit test the added logic in BPD.
5. Need to create the entries in ZFYPERIOD table for 2015 & 2016 Years.
6. Need to collect all the changes into the transport request and move to BPQ.
Test Plan
SNo
|
Test Scenario
|
Results
|
1
|
Need to check if the Key Figures are updated correctly as per the logic.
|
Key Figures should be updated correctly as per the logic.
|
2
|
Need to check if all the changes are collected into transprt request.
|
All the transports are collected into the transport request.
|
Solution Details
1. Need to create 2 key figures for last 3 months ZQTYSLL3M
& last 12 Months ZQTYSL12M
sales quantities.
2. Need to add the key figures to the Weekly inventory DSO ZDSOINVM.
3. Need to write the logic for the newly added key figures ZQTYSLL3M and ZQTYSL12M.
4. Need to test the added logic in BPD(BW 7.3 Development) & BPQ(BW 7.3 Quality).
5. Need to create the entries in ZFYPERIOD table for 2015 & 2016 Years.
6. Need to collect all the changes into the transport request.
Issues
Unit test cannot be performed in BPD due to junk data and so testing needs to be in BPQ.